SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetSpecInfoBySpecId] ( @fdSpecID VARCHAR(50) )
AS 
    SELECT  a.fdCollID,
            a.fdCollName,
            b.fdSpecID,
            b.fdSpecName,
            b.fdSpecType,
            c.fdSpecCampus,
            c.fdSpecIntroduction,
            c.fdSpecBachelorNumber,
            c.fdSpecMasterNumber,
            c.fdSpecDoctorNumber
    FROM    dbo.FS_College AS a
            INNER JOIN dbo.FS_Speciality AS b ON a.fdCollID = b.fdCollID
            INNER JOIN dbo.JOL_SpecialityIntroduction AS c ON b.fdSpecID = c.fdSpecID
    WHERE   b.fdSpecID = @fdSpecID

GO
